Previous Topic

Next Topic

Example: Find members by state or join date

This query extracts individual members who live in Texas or those who joined between 1993 and 1997, eliminating duplicates when the same rows are returned by the multiple subqueries.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select your sources:
    1. Browse to the Common folder containing business objects.
    2. Select Contact.
  4. Define the filtering rules:
    1. Select the Filters tab.
    2. Select Mode: Advanced.
    3. Filter on MemberType:
      • Property: MemberType
      • Comparison: Equal
      • Value:Member
    4. Add the filter.
    5. Filter on StateProvince.
      • Property: StateProvince
      • Comparison: Equal
      • Value: TX
    6. Add the filter.
    7. Select Add Filter.
    8. Select operator OR from the drop-down list.
    9. Filter on MemberType equal to Member:
      • Property: MemberType
      • Comparison: Equal
      • Value: Member
    10. Add the filter.
    11. Filter on Join Dates between.
      • Property: Join Date
      • Comparison: Between
      • Value: "1/1/1993","12/31/1997"
    12. Add the filter.
  5. Define the columns that display in the output:
    1. Select the Display tab.
    2. Select the Only display unique results option.
    3. Select the following columns: Id, StateProvince, Join Date.

      Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

    4. Using the Order drop-down list, assign
      • ID Order 1
      • StateProvince Order 2
      • Join Date Order 3
  6. Specify the sorting priority:
    1. Select the Sorting tab.
    2. Sort the results by Id.
    3. Add your selection.
  7. Save your settings.
  8. Run the query.

See Also

Query Examples

Example: Find recipients for e-mail

Example: Find current registrants

Example: Find registered members by city

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find total number of pledges by amount


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:04 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.